set SCMD=osql -E -S ".\SQLEXPRESS" -d "ConsultTracking"

REM Build tables and procedures

%SCMD% < ".\Set Up\TableSetup.sql"
%SCMD% < ".\Set Up\Contact sprocs.sql"
%SCMD% < ".\Set Up\Customer sprocs.sql"
%SCMD% < ".\Set Up\Invoice sprocs.sql"
%SCMD% < ".\Set Up\Job sprocs.sql"
%SCMD% < ".\Set Up\Location sprocs.sql"
%SCMD% < ".\Set Up\Note sprocs.sql"
%SCMD% < ".\Set Up\PO sprocs.sql"
%SCMD% < ".\Set Up\TableSetup.sql"
%SCMD% < ".\Set Up\Task sprocs.sql"
%SCMD% < ".\Set Up\User sprocs.sql"

REM Sample Data

%SCMD% < ".\Sample Data\CustomerInserts.sql"
%SCMD% < ".\Sample Data\UserInserts.sql"
%SCMD% < ".\Sample Data\JobInserts.sql"
%SCMD% < ".\Sample Data\InvoiceInserts.sql"

pause

